BHARAT SEVAK SAMAJ
Time: 2 hrs. Max. Marks: 100
I. Fill in the blanks: (10 x 1 = 10)
1. DBMS stands for -----------.
2. ---------------- contains the structure of the database.
3. User defined cursors are called ----------.
4. Aggregate function used to calculate average value is ------------.
5. -------------- Command is used to describe the structure of a table.
6. To modify the structure of a table, ----------- command is used.
7. ----------- Operation is used to access rows from two or more tables.
8. Errors in general are referred to as-----------.
9. Oracle supports -----------set operations.
10. UPDATE is a -----------command.
II. State whether True or False: (10 x 1 = 10)
1. UNION is a SET operator.
2. Primary key means UNIQUE and NULL.
3. SELECT command is used to describe the structure of a table.
4. A sub query is a query within a query.
5. String is a fundamental data type in Oracle.
6. The cursor must be defined in the ‘Declare’ section of the program.
7. To delete rows from a table, DEL command is used.
8. Primary key is a constraint for the column of a table.
9. By default sorting is in the ascending order.
10. Table names are not case sensitive
III. Answer any SIX of the following: (6 x 10 = 60)
1. Explain Codd’s rules.
2. What is an Exception?. Explain different types of exceptions.
3. Explain JOIN operation and set operators.
4. What are the differences between a DBMS and an RDBMS.
5. Write a program to check whether the given number is prime or not.
6. Explain Character functions and string functions with examples.
7. Explain the fundamental data types in ORACLE.
IV. Answer any ONE of the following: (1 x 20 = 20)
1. Explain Normalization in detail.
2. Explain different database models.